package com.tanhua.manager.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.tanhua.manager.domain.UserStatus;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.Date;

/**
 * @Author : wangpengfei
 * @Description :
 * @Date : 2021/3/1 11:56
 */
public interface UserStatusMapper extends BaseMapper<UserStatus> {
    @Select("select * from tb_user_status where DATE_FORMAT(un_freeze_time, '%Y-%m-%d') = #{time}")
    UserStatus findUserStatusByTime(@Param("time") Date date);
}
